﻿-- Creating table 'Appointments'
-- Creating table 'Appointments'
-- Creating table 'Appointments'
-- Creating table 'Appointments'
-- Creating table 'Appointments'
CREATE TABLE [dbo].[Appointments] (
    [AppointmentID] int IDENTITY(1,1) NOT NULL,
    [HN] nvarchar(8)  NOT NULL,
    [AppointmentDate] datetime  NOT NULL,
    [AppointmentTime] nvarchar(10)  NOT NULL,
    [ServiceID] int  NOT NULL,
    [Physician] nvarchar(5)  NOT NULL,
    [VisitDate] datetime  NULL,
    [Remark] nvarchar(max)  NULL,
    [IsDeleted] bit  NOT NULL
);














